"""
需求：
1. 在网页上找到某个员工的手机号
    网页地址：http://ihrm-test.itheima.net/
    登陆 ---> 员工
2. 查询bs_user表中该员工的is_delete的字段值(通过Pyhton代码实现)
    select is_delete from bs_user where mobile='某员工手机号'
3. 在网页上删除该员工
4. 查询bs_user表中该员工的is_delete的字段值(通过Pyhton代码实现)
"""

import pymysql

connect_sql = pymysql.connect(host='211.103.136.244', port=7061,
                              user='student', password='iHRM_student_2021',
                              database='ihrm', charset='utf8')

cursor = connect_sql.cursor()

num = cursor.execute('select is_delete from bs_user where mobile="18213332107"')

res = cursor.fetchone()
print(res)

cursor.close()
connect_sql.close()